package com.py.credit.service;

import com.py.credit.entity.CustomOuterInterface;
import com.py.framework.core.common.Page;

import java.util.List;
import java.util.Map;

/**
 * @author YaoS
 * @date 2020/4/23 20:01
 */
public interface CustomOuterInterfaceService {

    List<Map<String, Object>> getByConditionForPage(List<String> showColumns, String[] additionalColumns,
                                                    String condition, Page page);

    void add(CustomOuterInterface record);

    CustomOuterInterface getRecordById(int interfaceId);

    /**
     * 功能描述:sql执行器
     *
     * @param condition 查询参数
     * @param sql       查询sql
     * @return 查询结果
     * @author YaoS
     * @date 2020/4/23 20:01
     */
    List<Map<String, Object>> execute(String condition, String sql,String name);

    CustomOuterInterface getRecordByCode(String interfaceCode);

    void update(CustomOuterInterface customOuterInterface);

    List<Map<String, String>> getTableResource();

    List<Map<String, String>> getTableColums(String tableId);

    void addSgs(CustomOuterInterface customOuterInterface);

    /**
     * 功能描述: 查询sql条数
     *
     * @param condition 查询条件
     * @param sql       sql语句
     * @return 总数据
     * @author YaoS
     * @date 2020/4/23 20:15
     */
    Integer executeCount(String condition, String sql);

	
}
